Configuring CXP Extracts

Once all invoice data has been posted to the ledgers, CMPClosed Converged Monetisation Platform. The MDS Global product that supports customer care and billing for digital service providers. can optionally produce a set of extracts containing customerClosed In the context of the Cloud Monetisation Platform, an individual or organisation who has signed an agreement to take goods and services from a service provider. A customer receives a bill associated with one or more subscriptions, and can be a single end user or a large company with many subscriptions assigned to one agreement. invoice and hierarchical data for each bill run. These extracts are then used by the CXPClosed Customer Experience Platform, or CXP, is MDS Global's self-service app that allows business customers to manage their own accounts and subscriptions. Data Loader to load the extracted invoice and hierarchy data into the CXP database. This allows customers to view electronic versions of their invoices via CXP instead or as well as paper bills being produced.

 

The following steps describe how to configure and run the CXP extracts.

1. Define the sabre-analyser-extract properties

Navigate to System Configuration > Modules > Sabre Server > sabre- analyser-extract, and define the properties as required.

2. Define the extract supplement

To supplement extract data populated in CMP some additional configuration is required in the Analyser Extract Supplement (C4JWREP) file.

  • CXP requires that all unit of measure values be categorised. The Supplement Record of type U is used to categorise the unit of measure values in the invoice extract.

    The following configuration is required for Supplement Type U – Unit of Measure Category.

    Cross Reference Key 1 Supplement value 1
    Roaming Duration VOICE
    DMINS VOICE
    Seconds VOICE
    KB DATA
    N/A N/A
    Items ORDERS
    Text MESSAGE
    Weekend minutes VOICE
    Minutes VOICE
    Picture messages MESSAGE
    O2 Mobile minutes VOICE
    Duration VOICE
    Traveller minutes VOICE
    Messages MESSAGE
    Text messages MESSAGE
    Trafficline minutes OTHER
    Volume DATA
    Value MONETARY
    UK Fixed and Mobile minutes VOICE
    Free calls to the office VOICE
    Other UK mobile minutes VOICE
    Unlimited Landline allowance VOICE
    Unlimited Offpeak allowance VOICE
    Group Conferencing minutes OTHER
    Not Defined N/A

  • Discrepancies may exist between the NetworkClosed In the context of CMP, the infrastructure on which usage of registered customers will be measured – this could be a mobile phone network, broadband network or other non-telecommunications network. Type Descriptions stored within CMP and those configured in CXP. The Supplement Record of type N can be used to avoid issues when loading extracts into Spend AnalyserClosed An MDS Global product - a billing analytics tool. This has been replaced by CXP, MDS Global's self-care app..

    The following configuration is required for Supplement Type N – Network Type Description.

    Cross Reference Key 1 Supplement value 1
    B BREATHE
    BBAND O2 Broadband
    CANL O2 Mobile (CANL)
    CDIG O2 Mobile (CDIG)
    FIXED O2 Fixed Line
    I Internet
    MAAS3 MaaS360
    MWAN Managed Networks
    NGN NGN Telemarketing
    O Orange Network Services
    O2PSDO Data / Voice Link
    P Personal Numbers
    PNB Personal Numbers FW
    SWITCH O2 Switched Circuit
    V Vodafone
    VANL Vodafone Analogue
    VDIG Vodafone Digital
    MLL Mobile Landline VOIP
    SIPT SIP Trunking
    O2SERV O2 Services
    HVOICE Hosted Voice
    M2M Machine to Machine
    HSD001 High Speed Datalink
    O2SERV1 O2 Services
    MDM Mobile Device Management

3. Run the Hierarchy Analytics job

CMP allows for information to be extracted from its database and made available for third partyClosed Of software; a reusable component developed to be either freely distributed or sold by an entity other than the original vendor of the development platform. analysis.

Hierarchy information changes over time, for example subscriptions can move to different accounts, or accounts to a different corporate. While CMP stores only the current hierarchy, it is important that a historical view of the hierarchy is also available.

This job gathers the customer hierarchy information (subscriptionClosed A billing entity that incurs a charge. Examples include a network attached device whose usage you want to measure and charge for, or a monthly software subscription, accountClosed In the Cloud Monetisation Platform, a billing entity that can be used to manage payments on one or more subscriptions or payments for services. An account can hold details such as payments or invoices., corporate and groupClosed In the Customer Manager Platform hierarchy, the highest level of the structure. The group level can be used to group corporates. Groups can hold financial information.) that was in effect at the time of the most recent billing process.

This job is typically scheduled to run once per day after a billing process.

Please note that the Hierarchy Extract for a particular invoice run should always be requested prior to the equivalent Invoice Extract for that run to ensure that any account hierarchies which have not been previously invoiced are loaded into SA prior to their invoices. Failure to do this will result in an error when loading the invoice extract into CXP.

 

Once the SABRE Analyser Extract has been started and is actively running, it can process any number of requests for extracts. If the SABRE Analyser Extract job is stopped e.g. due to a machine IPL or if its subsystem has been ended, then it will not be able to process any requests to produce a set of extracts. In this situation it will be necessary to restart the SABRE Analyser Extract job.

4. Run the Invoice Analytics job

It is important to note that the Hierarchy Extract job must always be executed prior to the Invoice Extract job for a particular invoice run.

CMP allows for information to be extracted from its database and made available for third party analysis.

This job gathers details of invoices generated during the most recent billing process.

This job is typically scheduled to run once per day after a billing process.

 

For more information about these extract jobs, see the CMP Batch Jobs and JSONClosed JavaScript Object Notation. JSON is a lightweight format for storing and transporting data, often used when data is sent from a server to a web page. Schemas Guide. See also the jobs descriptions provided in the CMP Administration ConsoleClosed An operations web console that allows batch jobs to be scheduled, run manually and monitored. The console also provides for viewing and modification of business and user applicable system configuration..